getData("SELECT * FROM products WHERE status=1 ORDER BY id ASC");
foreach($run1 as $row1){
$run2 = $crud->getData("SELECT * FROM product_image WHERE pid='$row1[id]' ORDER BY id ASC LIMIT 1");
foreach($run2 as $row2){
$productimagefront = $row2['image'];
}
$result11 = $crud->getData("SELECT * FROM warrent WHERE pid='$row1[id]' ORDER BY id DESC LIMIT 1");
foreach($result11 as $res11){
$warrently = $res11['title'];
}
$run3 = $crud->getData("SELECT * FROM product_image WHERE pid='$row1[id]' ORDER BY id DESC LIMIT 1");
foreach($run3 as $row3){
$productimageback = $row3['image'];
}
$run4 = $crud->getData("SELECT * FROM wishlist WHERE productid='$row1[id]' and profileid='$profileid'");
foreach($run4 as $row4){
$heartproduct = $row4['productid'];
}
$run5 = $crud->getData("SELECT sum(status) as status FROM productreviews WHERE productid='$row1[id]'");
foreach($run5 as $row5){
$totalreview = $row5['status'];
}
$run6 = $crud->getData("SELECT AVG(rating) as average_rating FROM productreviews WHERE productid='$row1[id]'");
foreach($run6 as $row6){
$averageRating = round($row6['average_rating'], 2); // Round to 1 decimal place
}
$cat_id = $id;
$cat = $row1['maincategory'];
$array = explode(",", $cat);
$j = count($array);
for($i=0;$i<$j;$i++){
if($cat_id == $array[$i]){ ?>
![<?php echo $row1['name']; ?>](../img/<?php echo $productimagefront;?> "<?php echo $row1['name']; ?>")
![<?php echo $row1['name']; ?>](../img/<?php echo $productimageback;?> "<?php echo $row1['name']; ?>")
![<?php echo $row1['name']; ?>](../img/<?php echo $row10['image'];?>)